List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

develop, store and execute at least three queries, and retrieve and extract data at least three times

perform at least three calculations using control statements, operators and functions

prepare and manipulate at least three tables to meet specific requirements

create and use at least two views and at least two stored procedures according to task requirements.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

information gathering methods that may be used to apply query language in relational databases

industry standard database management systems (DBMS)

methods of connecting to DBMS

using data definition language (DDL), data manipulation language (DML) and data control language (DCL)

data analysis techniques

data mining

data source characteristics

information system features

required systems and procedures that may be used to apply query language in relational databases.

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice	Yes	No	Comments/feedback
Identify terminologies applicable to query language
Identify and build queries using required tools and environment
Sort and selectively retrieve values through query writing
Aggregate records by multiple attributes using an expression
Sort and filter aggregated records using an expression
Create queries and retrieve records from multiple tables
Retrieve records from multiple tables using different expressions and approaches
Filter records from multiple tables using an expression
Retrieve records from multiple tables using expressions, set operators and set logic
Construct and execute sub-queries
Perform a calculation on numeric values and an operation on text values using an expression
Perform an operation on date and time values using functions
Aggregate values and obtain required output using an expression
Identify required columns, data types, keys, relationships, indexes and constraints
Manipulate tables according to specific requirements
Create views according to information requirements
Retrieve and save data using a view and transactions
Drop a view from a database
Retrieve, insert and modify data using created and stored procedures according to information requirements
Create and execute stored procedures using one or more parameters
Drop a stored procedure from database
Create and test database triggers and perform specific required data-related functions

Assessment Cover Sheet

ICTPRG431 - Apply query language in relational databases

Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTPRG431 - Apply query language in relational databases

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: